﻿-- ================================================
-- Remarks: Not part of standard Stored Proc
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Ivy_SiteAdministration_Sys_RoleMaster_Delete')
	BEGIN
		DROP  Procedure  [Ivy_SiteAdministration_Sys_RoleMaster_Delete]
	END
GO

CREATE PROCEDURE [Ivy_SiteAdministration_Sys_RoleMaster_Delete]
-- =============================================
-- Author:		<Ram pravesh kr>
-- Create date: <01/10/2016>
-- Description:	<Ivy_SiteAdministration_Sys_RoleMaster_Delete>
-- =============================================

-- Add the parameters for the stored procedure here

	(
				@RoleKey int
	) 
AS 
BEGIN 
	-- SET NOCOUNT ON added to prevent extra result sets from interfering with DELETE statements. 
	SET NOCOUNT OFF; 

    DELETE FROM [Sys_RoleMaster] 
    WHERE 
		( 
			[RoleKey] = @RoleKey 
		); 

END 
GO 

-- =================================END=====================================

